UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/WxkDckPn4liLBK596jw4+v4BOY3104uUsJiMZkm/F0='
WHERE
key_id = '5564d642e8c0be97f4768863c683698d164a1bd59783b1563b5cb8dc10bd9057'
AND (
token = '/WxkDckPn4liLBK596jw4+v4BOY3104uUsJiMZkm/F0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)